Here's a routine to finnd the prime factors of a number ( Read more... )

Here it is in OopenOffice Basic ( Read more... )

There are several ways to open things from inside a OpenOffice document. The most accessible is the Hyperlink, but hyperlinks are limited. For instance, you can't open programs with them. Here are two short routines that allow you to open most other programs and other documents ( Read more... )

So, if you want to go in the other direction and convert a decimal number to a number in a different base system, here's how you can do it ( Read more... )

I like a lot of things about OpenOffice but the Basic language they use for their macros is a little embarrassing. For instance, I miss the Data....Read statements. In Basic (regular Basic, that is), if you want to load a bid array with constants, you use a Data statement and follow it up with a list of the values separated by commas. Then you set ( Read more... )

Here's a more ambitious program to convert a number from any base system to decimal. Calc has one but it only converts integers and there's a size limit. This one will also convert fractions. So, here's the whole program ( Read more... )

I'll start with a short routine I wrote to call up a spreadsheet page ( Read more... )

I heard often on the OpenOffice help forum that a spreadsheet is a business application and you shouldn't  be doing other things with it. If I have a spreadsheet, I feel downright betrayed if it doesn't do exactly what I want it to do. My spreadsheet is my layout engine. I'm so used to using the spreadsheet that I'm much more comfortable with it ( Read more... )

This will be rather short but an introduction of sorts. I have just had my eyes slashed (ala Un Chein Andalou), that is, I've just had cataracts removed from both eyes. And before Salvador Dali's movie images become too fixed in your brains, I should say that the process was prettymuch painless and Madison Street Surgery Center, Omni Eye Care, and ( Read more... )